-- ORACLE SQL - Get the 2 digits at the RIGHT end of a string SELECT SUBSTR('TN0001234567890345',-2) FROM DUAL;